SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 39049: Identity value substitutions might return an error in the Build Formula window

DetailsAboutRate It

In some cases, using identity values in a permission condition results in an error.

Here is an example expression that uses the identity value SAS.PersonName.

{[Organization].[All Organization], 
    [Organization].[All Organization].[SUB::SAS.PersonName]}

This expression resolves to the following:

{[Organization].[All Organization], 
    [Organization].[All Organization].[joeuser]}

Although this is a valid use of the identity value, the expression causes an error in the Build Formula window. Regardless of the error, you can still save the MDX expression and make use of it.

Note: The error message returned in SAS® 9.3 has been updated to say the following:

The syntax for your expression cannot be validated as correct. However, some valid 
expressions cannot be validated until a query is performed. If you believe this 
expression is correct, you may save this expression and validate the expression with 
a query. Do you want to continue and save this expression?

You are given the options Yes, No, or Cancel.

This is the expected behavior.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Management ConsoleMicrosoft® Windows® for 64-Bit Itanium-based Systems9.2 TS2M09.3 TS1M0
Microsoft Windows Server 2003 Datacenter 64-bit Edition9.2 TS2M09.3 TS1M0
Microsoft Windows Server 2003 Enterprise 64-bit Edition9.2 TS2M09.3 TS1M0
Microsoft Windows XP 64-bit Edition9.2 TS2M09.3 TS1M0
Microsoft® Windows® for x649.2 TS2M09.3 TS1M0
Microsoft Windows Server 2003 Datacenter Edition9.2 TS2M09.3 TS1M0
Microsoft Windows Server 2003 Enterprise Edition9.2 TS2M09.3 TS1M0
Microsoft Windows Server 2003 Standard Edition9.2 TS2M09.3 TS1M0
Microsoft Windows XP Professional9.2 TS2M09.3 TS1M0
Windows Vista9.2 TS2M09.3 TS1M0
64-bit Enabled AIX9.2 TS2M09.3 TS1M0
64-bit Enabled HP-UX9.2 TS2M09.3 TS1M0
64-bit Enabled Solaris9.2 TS2M09.3 TS1M0
HP-UX IPF9.2 TS2M09.3 TS1M0
Linux9.2 TS2M09.3 TS1M0
Linux for x649.2 TS2M09.3 TS1M0
Solaris for x649.2 TS2M09.3 TS1M0
SAS SystemSAS OLAP Cube StudioMicrosoft® Windows® for x644.24.29.2 TS2M09.3 TS1M0
Microsoft Windows Server 2003 Datacenter Edition4.24.29.2 TS2M09.3 TS1M0
Microsoft Windows Server 2003 Enterprise Edition4.24.29.2 TS2M09.3 TS1M0
Microsoft Windows Server 2003 Standard Edition4.24.29.2 TS2M09.3 TS1M0
Microsoft Windows XP Professional4.24.29.2 TS2M09.3 TS1M0
Windows Vista4.24.29.2 TS2M09.3 TS1M0
SAS SystemSAS Data Integration StudioMicrosoft® Windows® for x644.24.29.2 TS2M09.3 TS1M0
Microsoft Windows Server 2003 Datacenter Edition4.24.29.2 TS2M09.3 TS1M0
Microsoft Windows Server 2003 Enterprise Edition4.24.29.2 TS2M09.3 TS1M0
Microsoft Windows Server 2003 Standard Edition4.24.29.2 TS2M09.3 TS1M0
Microsoft Windows XP Professional4.24.29.2 TS2M09.3 TS1M0
Windows Vista4.24.29.2 TS2M09.3 TS1M0
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.